Converts text to a number for functions that require a numeric argument. It retains such special characters as commas, dollar signs, and decimals, except for cases when the characters conflict with numeric standards.
Format: TEXTTONUM (text)
Argument:
ΓÇó text: A text expression. Enclose text in quotation marks.
Example:
TEXTTONUM ("456abc78") returns 45678.
Shows that text that does not conform to standard number rules is removed from the text expression when using TEXTTONUM.